CREATE TABLE [dbo].[CustomTabFields]
(
[SEQ] [int] NOT NULL CONSTRAINT [DF_CustomTabFields_SEQ] DEFAULT ((0)),
[TABLE_NAME] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CustomTabFields_TABLE_NAME] DEFAULT (''),
[FIELD_NAME] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CustomTabFields_FIELD_NAME] DEFAULT (''),
[TABLE_FIELD_NAME] [varchar] (61) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CustomTabFields_TABLE_FIELD_NAME] DEFAULT (''),
[READ_ONLY] [bit] NOT NULL CONSTRAINT [DF_CustomTabFields_READ_ONLY] DEFAULT ((0)),
[NEW_ROW] [bit] NOT NULL CONSTRAINT [DF_CustomTabFields_NEW_ROW] DEFAULT ((0)),
[SQL_STRING] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CustomTabFields_SQL_STRING] DEFAULT (''),
[PROMPT] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CustomTabFields_PROMPT] DEFAULT (''),
[VALIDATION_TABLE] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CustomTabFields_VALIDATION_TABLE] DEFAULT (''),
[FIELD_TYPE] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CustomTabFields_FIELD_TYPE] DEFAULT (''),
[FIELD_LENGTH] [int] NOT NULL CONSTRAINT [DF_CustomTabFields_FIELD_LENGTH] DEFAULT ((0)),
[SQL_FIELD] [bit] NOT NULL CONSTRAINT [DF_CustomTabFields_SQL_FIELD] DEFAULT ((0)),
[EDIT_TYPES] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CustomTabFields_EDIT_TYPES] DEFAULT (''),
[MULTI_SELECT] [bit] NOT NULL CONSTRAINT [DF_CustomTabFields_MULTI_SELECT] DEFAULT ((0)),
[OBJ_HEIGHT] [int] NOT NULL CONSTRAINT [DF_CustomTabFields_OBJ_HEIGHT] DEFAULT ((0)),
[DECIMAL_POSITIONS] [tinyint] NOT NULL CONSTRAINT [DF_CustomTabFields_DECIMAL_POSITIONS] DEFAULT ((0)),
[AUTO_CONVERSION] [tinyint] NOT NULL CONSTRAINT [DF_CustomTabFields_AUTO_CONVERSION] DEFAULT ((0)),
[DEFAULT_VALUE] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CustomTabFields_DEFAULT_VALUE] DEFAULT (''),
[TITLE] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_CustomTabFields_TITLE] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
ALTER TABLE [dbo].[CustomTabFields] ADD CONSTRAINT [PK_CustomTabFields] PRIMARY KEY CLUSTERED ([SEQ], [TABLE_NAME], [FIELD_NAME], [TITLE]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[CustomTabFields] TO [IMIS]
GRANT SELECT ON  [dbo].[CustomTabFields] TO [IMIS]
GRANT INSERT ON  [dbo].[CustomTabFields] TO [IMIS]
GRANT DELETE ON  [dbo].[CustomTabFields] TO [IMIS]
GRANT UPDATE ON  [dbo].[CustomTabFields] TO [IMIS]
GO